﻿<?xml version="1.0" encoding="utf-8" ?>
<Database xmlns="http://happytemplate.org/demoSchema">
	<Table Name="Book" Schema="dbo">
		<Column Name="BookID"		DataType="Integer" PrimaryKey="true" Identity="true" />
		<Column Name="AuthorID"		DataType="Integer" />
		<Column Name="Title"		DataType="String" Length="100" />
		<Column Name="Isbn"			DataType="String" Length="20" />
		<Column Name="PublishDate"	DataType="DateTime" />
		<Column Name="PageCount"	DataType="Integer" Nullable="true"/>
	</Table>

	<Table Name="Author" Schema="dbo">
		<Column Name="AuthorID"		DataType="Integer" PrimaryKey="true" Identity="true"/>
		<Column Name="FirstName"	DataType="String" Length="50" />
		<Column Name="LastName"		DataType="String" Length="50" />
	</Table>
</Database>